﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$DBConnection$" type="$DbType$" defaultFormatter="bizobj ApprovalDataChange">
	<SqlStatement hasResults="true">
		SELECT
			id,
			actionType,
			bizObjData
		FROM
			ApprovalDataChange
		WHERE
			ApprovalDataChange.approvalDataId = @approvalDataId
		ORDER BY
			ApprovalDataChange.createdDate DESC
	</SqlStatement>
	<Param name="approvalDataId" type="UniqueIdentifier" />
</DbDataRequest>

<!--<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$DBConnection$" type="$DbType$" formatter="bizobjlist of ApprovalData">
	<Sql>
		SELECT
			ApprovalData.id as id,
			actionType as approvalDataChangeActionType,
			objectId as selectedObjectDataId,
			bizObjData as approvalDataChangebizObjData
		FROM
			ApprovalData
		INNER JOIN
			ApprovalDataChange ON
			ApprovalData.id = ApprovalDataChange.approvalDataId
		WHERE
			ApprovalData.objectId = @objectId
		ORDER BY
			ApprovalDataChange.createdDate DESC

</Sql>
	<Param name="objectId" type="UniqueIdentifier" />
</AdoNetDataAccess>-->
